--5 phases

--parse
--standardization -> query tree
--optimization
--    optimize everything that's optimizable
--compilation
--execution


--If stuff...
--    sql  (parameters)
--ELSE
--    sql  (parameters)


--For conditional logic it's better to consider
--Modularization...
--Hints...